package com.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.SimpleDateFormat;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class noteedit extends HttpServlet {

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request. setCharacterEncoding("UTF-8");
		   String event = request.getParameter("event");
		   String note = request.getParameter("note");
		   String no = request.getParameter("no");
		   String date = request.getParameter("date");
		  
		   try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		   String url ="jdbc:mysql://localhost:3306/graduatedesign" ;
			  Connection conn = null ;
			  Statement stmt = null ;
			  ResultSet rs = null;
			  SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
			  
			  String sql="update notes set date=?,event=?,note=? where no="+no; 
			  try {
				conn = DriverManager.getConnection(url, "root", "root") ;
				stmt = conn.createStatement() ;
				PreparedStatement preStmt=conn.prepareStatement(sql);  
	            preStmt.setString(1, date);  
	            preStmt.setString(2, event);  
	            preStmt.setString(3, note);
	            int suc = preStmt.executeUpdate(); 
	            if(suc!=0){
	            	response.sendRedirect("admin/notemanage.jsp") ;
	            }
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
         doGet(request, response);
	}
}
